<?
include("config.php");

$s = mssql_query("DROP VIEW VLP");
if($s){
	$q = mssql_query("CREATE VIEW VLP AS SELECT A.NIK, B.Nama, A.periode, A.id FROM S_LP AS A INNER JOIN Karyawan AS B ON A.NIK = B.NIK");
	if($q){
		echo"Update View OK, Thank You";
	}
/*
SELECT     A.NIK, B.Nama, A.periode, A.id
FROM         dbo.S_LP AS A INNER JOIN
                      dbo.Karyawan AS B ON A.NIK = B.NIK
					  */
}					  
?>